home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
CICA 1993 April
/
CICA MS Windows - April 1993.iso
/
unzipped
/
demo
/
quasrsql
/
query16.sql
< prev
next >
Wrap
Text File
|
1991-10-26
|
191b
|
12 lines
create table temp (
pno char(6),
totqty integer
);
insert into temp (pno, totqty)
select pno, sum(qty) from sp group by pno;
select * from temp;
drop table temp;